<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ include file="/base/base.jsp"%>
<%@ include file="/base/database.jsp" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport"
	content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
<meta name="renderer" content="webkit">
<title>管理员个人信息</title>
<link rel="stylesheet" href="css/pintuer.css">
<link rel="stylesheet" href="css/admin.css">
<link rel="shortcut icon" href="images/logo.jpg">
<script src="js/jquery.js"></script>
<script src="js/pintuer.js"></script>

</head>

<body>

  <div class="panel admin-panel">
    <div class="panel-head"><strong class="icon-reorder">辅导员个人信息</strong> </div>

    <table class="table table-hover text-center">
      <tr>
       			<th>序号</th>
				<th>工号</th>
				<th>辅导员姓名</th>
				<th>所在学院</th>
				<th>二级学院编号</th>			
				<th>电话号码</th>
				<th>操作</th>
      </tr>
    
				
				
		
			<% 
			    request.setCharacterEncoding("utf-8");
			   
			    String  keyword=request.getParameter("keyword");
			
				StringBuffer sqlBuff = new StringBuffer();
				sqlBuff.append("select * from sys_instructor limit 7,6");
				String sql = sqlBuff.toString();
				//2:查询数据库记录
				//2.1 加载驱动
				Connection conn = getConn();
				//2.3:由给定Connection类型的连接对象conn执行SQL指令的PrepareStatement类型的对象pstmt
				PreparedStatement pstmt = conn.prepareStatement(sql);

				//2.4:PrepareStatement类型的对象pstmt执行SQL查询语句并返回结果
				ResultSet rs = pstmt.executeQuery();
				//定义int序号变量
				
				int index=7;
				
				while (rs.next()) {
					
				String instID=rs.getNString("instID");
				String instName=rs.getNString("instName");
				String institude=rs.getNString("institude");							
				String depID=rs.getNString("depID");			
				String telephone=rs.getNString("telephone");
			
			%>

			<tr>
				<td><%=index++%></td>
				<td><%=instID%></td>
				<td><%=instName%></td>
				<td><%=institude%></td>					
				<td><%=depID %></td>
				<td><%=telephone %></td>				
				<td><div class="button-group">
				 <a class="button border-main" href="<%=path%>/page/instructor/instructor_edit.jsp?instID=<%=instID%>"><span class="icon-edit"></span> 修改</a> <a class="button border-red" href="<%=path%>/page/instructor/action_delinstructor.jsp?instID=<%=instID%>" ><span class="icon-trash-o"></span> 删除</a>  </div></td>
			</tr>
			<%
				}
			%>
    </table>
    </div>
  <div class="pagelist"> <a href="page/instructor/instructor_list.jsp">上一页</a> <span class="current"><select name="tern" onchange="window.location=this.value">
  <option>跳页</option>
  <option value="instructor_list.jsp">1</option>
  <option value="instructor_page2.jsp">2</option>
  <option value="instructor_page3.jsp">3</option>
  </select></span><a href="page/instructor/instructor_list.jsp">1</a><a href="page/instructor/instructor_page2.jsp">2</a><a href="page/instructor/instructor_page3.jsp">3</a><a href="page/instructor/instructor_page3.jsp">下一页</a><a href="page/instructor/instructor_page3.jsp">尾页</a> </div>
</body>
</html>
